The Tetris-Algorithm for Sorted Reading from UB-Tree
نویسنده
چکیده
1.1 Addresses, Areas and Regions We iteratively define an area A as a special subspace of a d-dimensional cube as follows: Split the cube with respect to every dimension in the middle, resulting in 2 subcubes numbered in some arbitrary but fixed order (for our implementation and this paper we used Z-ordering) from 1 to 2. An area A1 of level 1 consists of the first i1 closed subcubes. i1 determines A1 uniquely. We call i1 the address of A1 and write A1 = area(i1). The empty area has the address ε. To enlarge an area, we iteratively add an area with address i2 ∈{0,1,...,2-1} of the next subcube with number i1+1. The address of this enlarged area A2 is i1.i2, which is lexicographically larger than the address i1 of area A1. Next we may enlarge A2 by adding an area of the brother subcube i2+1 of i2, etc. The left part of figure 1 shows four areas area(0.0.1), area(1.3.2), area(2.1) and area(3) of a twodimensional universe. The shaded subcubes of the two-dimensional universe belong to the corresponding area.
منابع مشابه
Efficient Processing of the Cube Operator
This paper presents a part of the doctoral work with the theme: “The impact of sorted reading from UB-trees on relational database systems”. Based on [Mar99] this doctoral work deals with the problems of the efficient implementation and analysis of sorted reading (UB-Cache [Bay97b], Tetris -Algorithm [MB98], [MZB99]) and its effect on query-processing and query optimization in relational databa...
متن کاملThe UB - Tree : Performance of Multidimensional Range Queries
We investigate the usability and performance of the UB-Tree (universal B-Tree) for multidimensional data, as they arise in all relational databases and in particular in datawarehousing and data-mining applications. The UB-Tree is balanced and has all the guaranteed performance characteristics of B-Trees, i.e., it requires linear space for storage and logarithmic time for the basic operations of...
متن کاملThe UB - Tree : Performance of Multidimensional Range
We investigate the usability and performance of the UB-Tree (universal B-Tree) for multidimensional data, as they arise in all relational databases and in particular in datawarehousing and data-mining applications. The UB-Tree is balanced and has all the guaranteed performance characteristics of B-Trees, i.e., it requires linear space for storage and logarithmic time for the basic operations of...
متن کاملProcessing Operations with Restrictions in RDBMS without External Sorting: The Tetris Algorithm
Most operations of the relational algebra or SQL require a sorted stream of tuples for efficient processing. Therefore, processing complex relational queries relies on efficient access to a table in some sort order. In principle, indexes could be used, but they are superior to a full table scan only, if the result set is sufficiently restricted in the index attribute. In this paper we present t...
متن کاملExploitation of Pre-sortedness for Sorting in Query Processing: The TempTris-Algorithm for UB-Trees
Bulk loading is used to efficiently build a table or access structure, if a large data set is available at index creation time, e.g., the spool process of a data warehouse or the creation of intermediate results during query processing. In this paper we introduce the TempTris algorithm that creates a multidimensional partitioning from a one-dimensionally sorted stream of tuples. In order to ach...
متن کامل